单据设置

概述

单据类型

** New **单据类型
select b.ad_reference_id, b.name as ad_reference_name, a.name as ad_ref_list_name , c.name
from ad_ref_list a
join ad_reference b on a.ad_reference_id=b.ad_reference_id
join ad_ref_list_trl c on a.ad_ref_list_id = c.ad_ref_list_id
where b.name ~'DocBaseType'
order by 3
SELECT AD_Table_ID, TableName 
FROM AD_Table t 
WHERE EXISTS 
    (SELECT * FROM AD_Column c 
        WHERE t.isview='N' AND t.AD_Table_ID=c.AD_Table_ID AND c.IsActive='Y' 
                   AND  c.ColumnName='Posted');

单据序号

单据类型校验

反向单据

反向单据应用

工作流